<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/Ling1604/article/details/71713692"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql错误：1064 - Ling1604的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql错误：1064 - Ling1604的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-2eefd34acf.min.css">
        <script type="text/javascript">
        var username = "Ling1604";
        var blog_address = "https://blog.csdn.net/ling1604";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/Ling1604/article/details/71713692"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-yellow";
        // 收藏所需数据
        var articleTitle = "mysql错误：1064";
        var articleDesc = "mysql错误：1064";
        // 第四范式所需数据
        var articleTitles = "mysql错误：1064 - Ling1604的博客";
        
        var nickName = "Ling1604";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/ling1604/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/Ling1604/article/details/71713692";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql错误：1064</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年05月12日 11:43:34</span>
                    <a class="follow-nickName" href="https://me.csdn.net/Ling1604" target="_blank">Ling1604</a>
                    <span class="read-count">阅读数 3553</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>1、错误提示</p>



<pre class="prettyprint"><code class=" hljs livecodeserver">You have <span class="hljs-operator">an</span> error <span class="hljs-operator">in</span> your SQL syntax; check <span class="hljs-operator">the</span> manual that corresponds <span class="hljs-built_in">to</span> your MySQL server <span class="hljs-built_in">version</span> <span class="hljs-keyword">for</span> <span class="hljs-operator">the</span> <span class="hljs-constant">right</span> syntax <span class="hljs-built_in">to</span> use near <span class="hljs-string">''</span> <span class="hljs-keyword">at</span> <span class="hljs-built_in">line</span> <span class="hljs-number">4</span></code></pre>

<p>2、错误sql</p>



<pre class="prettyprint"><code class=" hljs sql"><span class="hljs-operator"><span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">PROCEDURE</span> sp1 (<span class="hljs-keyword">IN</span> p <span class="hljs-keyword">INT</span> )
COMMENT <span class="hljs-string">'insert into a int value'</span>
<span class="hljs-keyword">BEGIN</span> 
    /*定义一个整形变量*/
    <span class="hljs-keyword">DECLARE</span> v1 <span class="hljs-keyword">INT</span>;</span>
    <span class="hljs-comment">/*将输入参数的值赋给变量*/</span>
    <span class="hljs-operator"><span class="hljs-keyword">SET</span> v1=p;</span>
    <span class="hljs-comment">/*执行插入操作*/</span>
    <span class="hljs-operator"><span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">INTO</span> test(id) <span class="hljs-keyword">VALUES</span> (v1);</span>
<span class="hljs-operator"><span class="hljs-keyword">END</span></span></code></pre>

<p>3、改正，在存储过程开始加上分隔符，并以分隔符结尾 <br>
– 带输入参数的存储过程</p>



<pre class="prettyprint"><code class=" hljs sql">DELIMITER $$
<span class="hljs-operator"><span class="hljs-keyword">DROP</span> <span class="hljs-keyword">PROCEDURE</span> <span class="hljs-keyword">IF</span> <span class="hljs-keyword">EXISTS</span> sp1$$
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">PROCEDURE</span> sp1 (<span class="hljs-keyword">IN</span> p <span class="hljs-keyword">INT</span>)
COMMENT <span class="hljs-string">'insert into a int value'</span>
<span class="hljs-keyword">BEGIN</span> 
     /*声明一个变量*/
     <span class="hljs-keyword">DECLARE</span> v1 <span class="hljs-keyword">INT</span>;</span>
    <span class="hljs-comment">/*将输入参数的值赋给变量*/</span>
    <span class="hljs-operator"><span class="hljs-keyword">SET</span> v1=p;</span>
    <span class="hljs-comment">/*执行插入操作*/</span>
    <span class="hljs-operator"><span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">INTO</span> test(id) <span class="hljs-keyword">VALUES</span> (v1);</span>
<span class="hljs-operator"><span class="hljs-keyword">END</span>$$</span></code></pre>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/Ling1604/article/details/71713692","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/Ling1604/article/details/71713692","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
			<div class="unlogin-box text-center">
			博主设置当前文章不允许评论。
		</div>
		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/svap1/article/details/23839327","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/svap1/article/details/23839327","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/svap1/article/details/23839327" target="_blank" title="mysql 1064错误原因及解决办法">
		<h4 class="text-truncate oneline">
				mysql <em>1064</em>错误原因及解决办法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/svap1/article/details/23839327" target="_blank" title="mysql 1064错误原因及解决办法">
				<span class="desc oneline">1064错误意思是说我的SQL语法错误，然后显示错误的具体位置。查看待更新的内容，以及执行跟新的php语句。php语句如下：if(!$handle=@fopen($fname,&amp;quot;r&amp;quot...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/svap1">来自：	<span class="blog_title"> svap1的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xc_zhou/article/details/80952199","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xc_zhou/article/details/80952199","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xc_zhou/article/details/80952199" target="_blank" title="关于MySQL的1064错误">
		<h4 class="text-truncate oneline">
				关于MySQL的<em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-09</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xc_zhou/article/details/80952199" target="_blank" title="关于MySQL的1064错误">
				<span class="desc oneline">MySQL的1064错误是SQL语句写的有问题时出现的，即SQL的语法错误。笔者常常使用MySQL-python这个库来对MySQL进行操作，代码中报这个错误的一般是cursor.execute(sq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xc_zhou">来自：	<span class="blog_title"> 周小董</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Naploen8/article/details/50339671","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Naploen8/article/details/50339671","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Naploen8/article/details/50339671" target="_blank" title="Mysql 常见错误代码： 1064">
		<h4 class="text-truncate oneline">
				Mysql 常见错误代码： <em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-17</span>
				<span class="read-num hover-hide">
					阅读数 
					5万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Naploen8/article/details/50339671" target="_blank" title="Mysql 常见错误代码： 1064">
				<span class="desc oneline">错误提示：错误代码：1064YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMariaDBserverversionf...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Naploen8">来自：	<span class="blog_title"> 晓月清松</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wukong_666/article/details/70208749","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wukong_666/article/details/70208749","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wukong_666/article/details/70208749" target="_blank" title="mysql 报错ERROR 1064 (42000)，原因使用了mysql保留字">
		<h4 class="text-truncate oneline">
				mysql 报错ERROR <em>1064</em> (42000)，原因使用了mysql保留字		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-17</span>
				<span class="read-num hover-hide">
					阅读数 
					8万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wukong_666/article/details/70208749" target="_blank" title="mysql 报错ERROR 1064 (42000)，原因使用了mysql保留字">
				<span class="desc oneline">执行select语句：select*fromcfg_parameterwherekey='nSJtifqVSI7HkPrKHlxhD6';ERROR1064(42000):Youhaveanerror...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wukong_666">来自：	<span class="blog_title"> wukong_666的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/chenmoshashou2/article/details/80464911","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/chenmoshashou2/article/details/80464911","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chenmoshashou2/article/details/80464911" target="_blank" title="MySQL更改口令报错ERROR 1064">
		<h4 class="text-truncate oneline">
				MySQL更改口令报错ERROR <em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-26</span>
				<span class="read-num hover-hide">
					阅读数 
					5347</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chenmoshashou2/article/details/80464911" target="_blank" title="MySQL更改口令报错ERROR 1064">
				<span class="desc oneline">MySQL必知必会P203更改口令，语句为：mysql&amp;amp;gt;SETpasswordforben=password('123456');运行会报错ERROR1064(42000):Youhav...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chenmoshashou2">来自：	<span class="blog_title"> chenmoshashou2的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/310017343","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/310017343","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<a href="https://bbs.csdn.net/topics/310017343" target="_blank">
		<h4 class="text-truncate oneline">
				mysql建表： 出现 error 1604（42000）的错误，建表的源代码如正文（是在数据库“test”中建立这个表的）		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-19</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql&gt; use test; Database changed mysql&gt; CREATE TABLE Order -&gt; ( -&gt; number INTEGER, -&gt; shippingAddre</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"http://ask.csdn.net/questions/390352","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_614","dest":"http://ask.csdn.net/questions/390352","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<a href="http://ask.csdn.net/questions/390352" target="_blank">
		<h4 class="text-truncate oneline">
				Navicat for MYSQL  <em>1064</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-09</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zm9898/article/details/89526555","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zm9898/article/details/89526555","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zm9898/article/details/89526555" target="_blank" title="mysql错误代码之1064">
		<h4 class="text-truncate oneline">
				<em>mysql错误</em>代码之<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-25</span>
				<span class="read-num hover-hide">
					阅读数 
					403</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zm9898/article/details/89526555" target="_blank" title="mysql错误代码之1064">
				<span class="desc oneline">sql语句中词和mysql的关键字冲突了，用``（tab键上方）将词括起来就好了。原来的sql语句&amp;lt;insertid=&quot;insert&quot;parameterType=&quot;com.zhangman.ma...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zm9898">来自：	<span class="blog_title"> zm9898的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/imbingoer/article/details/85063337","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/imbingoer/article/details/85063337","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/imbingoer/article/details/85063337" target="_blank" title="mysql 错误。ERROR 1064 (42000)删除数据库的时候遇到的问题">
		<h4 class="text-truncate oneline">
				mysql 错误。ERROR <em>1064</em> (42000)删除数据库的时候遇到的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-18</span>
				<span class="read-num hover-hide">
					阅读数 
					1004</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/imbingoer/article/details/85063337" target="_blank" title="mysql 错误。ERROR 1064 (42000)删除数据库的时候遇到的问题">
				<span class="desc oneline">问题在删除数据库的时候，遇到了一个问题后来百度了一大把，发现要删除的数据库名要要引号引起来。然后添加引号继续错误。。。。。。。。。。。。。。。。。。。。。。。。继续百度，发现添加的引号错了，看下图。真...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/imbingoer">来自：	<span class="blog_title"> imbingoer的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qbg291932598/article/details/76122081","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qbg291932598/article/details/76122081","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qbg291932598/article/details/76122081" target="_blank" title="MySQL创建表 错误代码1064">
		<h4 class="text-truncate oneline">
				MySQL创建表 错误代码<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-26</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qbg291932598/article/details/76122081" target="_blank" title="MySQL创建表 错误代码1064">
				<span class="desc oneline">MySQL创建表错误代码1064用sqlyog图形化界面写的语句复制如下：CREATETABLE`student`.`student`(`id`INT(12)NOTNULLAUTO_INCREMENT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qbg291932598">来自：	<span class="blog_title"> 秦彬桂的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ShiMengRan107/article/details/81132994","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ShiMengRan107/article/details/81132994","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ShiMengRan107/article/details/81132994" target="_blank" title="MYSQL 1064 错误">
		<h4 class="text-truncate oneline">
				MYSQL <em>1064</em> 错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-20</span>
				<span class="read-num hover-hide">
					阅读数 
					2108</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ShiMengRan107/article/details/81132994" target="_blank" title="MYSQL 1064 错误">
				<span class="desc oneline">用MySQL执行批量插入数据，格式如下：declareiinteger;--定义变量begini:=0000;loop/*插入数据*/insertinto`表名`(字段1,字段2,...)values...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ShiMengRan107">来自：	<span class="blog_title"> 释梦燃的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/myflysun/article/details/81203764","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/myflysun/article/details/81203764","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/myflysun/article/details/81203764" target="_blank" title="MySQL的1064错误 insert">
		<h4 class="text-truncate oneline">
				MySQL的<em>1064</em>错误 insert		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-25</span>
				<span class="read-num hover-hide">
					阅读数 
					2267</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/myflysun/article/details/81203764" target="_blank" title="MySQL的1064错误 insert">
				<span class="desc oneline">java.sql.SQLException:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverve...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/myflysun">来自：	<span class="blog_title"> 无心人的终点</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390207761","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390207761","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<a href="https://bbs.csdn.net/topics/390207761" target="_blank">
		<h4 class="text-truncate oneline">
				mysql 总报错 Error Code : <em>1064</em> 请高手指点		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">09-10</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我是个新手 找了一下午错误了 头大了 请高手指点 到底是哪里错了。。 DELIMITER $$ CREATE PROCEDURE `pr_addshieldstateparam`( IN mobile</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42215286/article/details/80344900","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42215286/article/details/80344900","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42215286/article/details/80344900" target="_blank" title="MySql ERROR 1064 (42000)同样的错误，不一样的解决方法">
		<h4 class="text-truncate oneline">
				MySql ERROR <em>1064</em> (42000)同样的错误，不一样的解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42215286/article/details/80344900" target="_blank" title="MySql ERROR 1064 (42000)同样的错误，不一样的解决方法">
				<span class="desc oneline">开始时代码是这样：然后运行：代码根本毫无错误，但为什么会出错呢？在我花了2个小时后终于知道了答案。我没有加分号!!!!!修改后代码：然后再次运行后：再一次为自己的无知和粗心感到绝望！！！......</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42215286">来自：	<span class="blog_title"> Leo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43621681/article/details/88043446","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43621681/article/details/88043446","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43621681/article/details/88043446" target="_blank" title="【报错解决】+【MySQL】ERROR 1064（42000）">
		<h4 class="text-truncate oneline">
				【报错解决】+【MySQL】ERROR <em>1064</em>（42000）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-01</span>
				<span class="read-num hover-hide">
					阅读数 
					875</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43621681/article/details/88043446" target="_blank" title="【报错解决】+【MySQL】ERROR 1064（42000）">
				<span class="desc oneline">MySQL错误：ERROR1064（42000）出现情形报错原因解决方案出现情形在修改账户密码时，我输入了以下命令：mysql&amp;amp;amp;amp;gt;setpassword=password(...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43621681">来自：	<span class="blog_title"> weixin_43621681的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/110088520","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/110088520","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<a href="https://bbs.csdn.net/topics/110088520" target="_blank">
		<h4 class="text-truncate oneline">
				mysql <em>1064</em> 一般是什么错误？？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-22</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">SELECT * FROM link_acc WHERE ((isauditing&gt;'0' AND usergroup IN (-1)) OR (isauditing='0' AND usergrou</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/facing/article/details/58585733","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/facing/article/details/58585733","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/facing/article/details/58585733" target="_blank" title="在windows下安装MySQL5.7">
		<h4 class="text-truncate oneline">
				在windows下安装MySQL5.7		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-28</span>
				<span class="read-num hover-hide">
					阅读数 
					74</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/facing/article/details/58585733" target="_blank" title="在windows下安装MySQL5.7">
				<span class="desc oneline">MySQL数据库支持JSON，为了使用这一特性，使用新的MySQL数据库5.7版本。下载的版本是解压版本，直接解压1.配置文件，增加datadir=C:\mysql\data2.在bin目录，执行命令...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/facing">来自：	<span class="blog_title"> facing的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/liuzhuang2017/article/details/81181521","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liuzhuang2017/article/details/81181521","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liuzhuang2017/article/details/81181521" target="_blank" title="MySQL ERROR 1064  (42000)">
		<h4 class="text-truncate oneline">
				MySQL ERROR <em>1064</em>  (42000)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liuzhuang2017/article/details/81181521" target="_blank" title="MySQL ERROR 1064  (42000)">
				<span class="desc oneline">今天笔者写了一条SQL语句，不管怎么修改始终报错，可是也没有找到原因，后来才发现是语法的错误。CREATETABLE't'('a'int(11)NOTNULLauto_increment,'b'var...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liuzhuang2017">来自：	<span class="blog_title"> liuzhuang2017的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ws379374000/article/details/78285607","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ws379374000/article/details/78285607","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ws379374000/article/details/78285607" target="_blank" title="Mysql创建存储过程时出现ERROR 1064错误">
		<h4 class="text-truncate oneline">
				Mysql创建存储过程时出现ERROR <em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-19</span>
				<span class="read-num hover-hide">
					阅读数 
					9428</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ws379374000/article/details/78285607" target="_blank" title="Mysql创建存储过程时出现ERROR 1064错误">
				<span class="desc oneline">ERROR1064(42000):ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourM...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ws379374000">来自：	<span class="blog_title"> KK的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/shamaya/article/details/1709467","strategy":"BlogCommendFromBaidu","index":"19"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/shamaya/article/details/1709467","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shamaya/article/details/1709467" target="_blank" title="mysql error:1064解决">
		<h4 class="text-truncate oneline">
				mysql error:<em>1064</em>解决		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-26</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shamaya/article/details/1709467" target="_blank" title="mysql error:1064解决">
				<span class="desc oneline">症状：用创建表时用中文属性出现Error:1064。解决方法：中文属性不能设成VARCHAR，设成VARCHAR(45)或VARCHAR(100)等就可以建表了。当然mysql的默认charset已设...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shamaya">来自：	<span class="blog_title"> 沙玛</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/tqwer/article/details/70212187","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/tqwer/article/details/70212187","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tqwer/article/details/70212187" target="_blank" title="mysql命令方式报错误代码1064">
		<h4 class="text-truncate oneline">
				mysql命令方式报错误代码<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-17</span>
				<span class="read-num hover-hide">
					阅读数 
					3867</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tqwer/article/details/70212187" target="_blank" title="mysql命令方式报错误代码1064">
				<span class="desc oneline">写脚本创建数据库报YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortheri...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tqwer">来自：	<span class="blog_title"> tqwer的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39654446/article/details/77678917","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39654446/article/details/77678917","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_39654446/article/details/77678917" target="_blank" title="navicat for mysql 创建存储过程时报错1064">
		<h4 class="text-truncate oneline">
				navicat for mysql 创建存储过程时报错<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-29</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_39654446/article/details/77678917" target="_blank" title="navicat for mysql 创建存储过程时报错1064">
				<span class="desc oneline">在navicatformysql创建函数，保存的时候出现1064错误基本上是两个原因导致的：1：是存储过程的参数没有设定长度导致的，我们在Navicat中创建存储过程时参数的长度需要自己动手去添加的否...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_39654446">来自：	<span class="blog_title"> 超级无敌皮皮超的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wenruo95/article/details/48225799","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wenruo95/article/details/48225799","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wenruo95/article/details/48225799" target="_blank" title="mysql中1064错误和字符处理">
		<h4 class="text-truncate oneline">
				mysql中<em>1064</em>错误和字符处理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					4244</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wenruo95/article/details/48225799" target="_blank" title="mysql中1064错误和字符处理">
				<span class="desc oneline">在java程序中的一些字符串想要保存到数据库中，就不得不注意这个问题，直接贴代码。sql=&quot;insertintodata_tb(purpose,user_name)&quot;+&quot;values(\'&quot;+purp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wenruo95">来自：	<span class="blog_title"> wenruo95的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/alexyangbjb/article/details/49097687","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/alexyangbjb/article/details/49097687","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/alexyangbjb/article/details/49097687" target="_blank" title="Mysql创建存储过程时，出现ERROR 1064 (42000):的原因的一种">
		<h4 class="text-truncate oneline">
				Mysql创建存储过程时，出现ERROR <em>1064</em> (42000):的原因的一种		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-13</span>
				<span class="read-num hover-hide">
					阅读数 
					7922</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/alexyangbjb/article/details/49097687" target="_blank" title="Mysql创建存储过程时，出现ERROR 1064 (42000):的原因的一种">
				<span class="desc oneline">下面的Error信息，大家看着挺熟悉的吧。ERROR1064(42000):ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualt...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/alexyangbjb">来自：	<span class="blog_title"> alexyangbjb的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/tcjc5214/article/details/8594867","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/tcjc5214/article/details/8594867","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tcjc5214/article/details/8594867" target="_blank" title="mysql errorno 代号的各种含义">
		<h4 class="text-truncate oneline">
				mysql errorno 代号的各种含义		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-20</span>
				<span class="read-num hover-hide">
					阅读数 
					587</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tcjc5214/article/details/8594867" target="_blank" title="mysql errorno 代号的各种含义">
				<span class="desc oneline">130：文件格式不正确。(还不是很清楚错误的状况)　　145：文件无法打开。　　1005：创建表失败。　　1006：创建数据库失败。　　1007：数据库已存在，创建数据库失败。　　1008：数据库不存...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tcjc5214">来自：	<span class="blog_title"> tcjc5214的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390136939","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390136939","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<a href="https://bbs.csdn.net/topics/390136939" target="_blank">
		<h4 class="text-truncate oneline">
				mysql中declare的问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-16</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">如题，我在SQLyog Enterprise中执行如下代码，但是每次都是declare报错；在mysql命令行中也是如此，请问该怎么用declare呢？ 代码如下： CREATE PROCEDURE</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392039467","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392039467","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<a href="https://bbs.csdn.net/topics/392039467" target="_blank">
		<h4 class="text-truncate oneline">
				MySql输入任何语句都报<em>1064</em>错误怎么解决		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">10-28</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">在命令提示符输入是没有问题的,仅仅在图形化界面出错,不管输入什么,都是1064,求解决</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392391596","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392391596","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<a href="https://bbs.csdn.net/topics/392391596" target="_blank">
		<h4 class="text-truncate oneline">
				[Mysql]新手求助：设置密码出现<em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-04</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">网上找了很久都没法解决，贴图。 刚进来没有认识的朋友，邀请了些系统推荐的朋友答复。实在不好意思。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/t_x_x/article/details/88565669","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/t_x_x/article/details/88565669","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/t_x_x/article/details/88565669" target="_blank" title="sqlyog数据库执行报错，错误代码： 1064">
		<h4 class="text-truncate oneline">
				sqlyog数据库执行报错，错误代码： <em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-15</span>
				<span class="read-num hover-hide">
					阅读数 
					1025</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/t_x_x/article/details/88565669" target="_blank" title="sqlyog数据库执行报错，错误代码： 1064">
				<span class="desc oneline">具体内容：错误代码：1064YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfor...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/t_x_x">来自：	<span class="blog_title"> t_x_x的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390649119","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390649119","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<a href="https://bbs.csdn.net/topics/390649119" target="_blank">
		<h4 class="text-truncate oneline">
				phpmyadmin 中创建MYSQL函数function 报错：<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">11-21</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">在PHPMYADMIN中创建MYSQL 函数，报错： 需求： 需要创建一个MySQL函数，调用就可以获得表 users的用户数。 报错： 下列查询失败了: &quot;CREATE FUNCTION `coun</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392409829","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392409829","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<a href="https://bbs.csdn.net/topics/392409829" target="_blank">
		<h4 class="text-truncate oneline">
				MYSQL自定义函数报<em>1064</em>错		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-04</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">想做一个字符串分割自定义函数，结果老是报错，请帮助看一下，谢谢！ CREATE function GetCharIndexNum (`@findstring` varchar(255),`@strin</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/liudsl/article/details/79821783","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liudsl/article/details/79821783","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liudsl/article/details/79821783" target="_blank" title="python2.7 pymysql中  pymysql.err.ProgrammingError:1064, You have an error in your SQL syntax;">
		<h4 class="text-truncate oneline">
				python2.7 pymysql中  pymysql.err.ProgrammingError:<em>1064</em>, You have an error in your SQL syntax;		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-04</span>
				<span class="read-num hover-hide">
					阅读数 
					7689</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liudsl/article/details/79821783" target="_blank" title="python2.7 pymysql中  pymysql.err.ProgrammingError:1064, You have an error in your SQL syntax;">
				<span class="desc oneline">下面说一下 python2.7pymysql中 pymysql.err.ProgrammingError:(1064,u&amp;quot;YouhaveanerrorinyourSQLsyntax;错误可能...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liudsl">来自：	<span class="blog_title"> liudsl的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sodalife/article/details/83279438","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sodalife/article/details/83279438","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sodalife/article/details/83279438" target="_blank" title="python使用pymysql操作MySQL错误代码1054和1064处理">
		<h4 class="text-truncate oneline">
				python使用pymysql操作<em>MySQL错误</em>代码1054和<em>1064</em>处理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1545</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sodalife/article/details/83279438" target="_blank" title="python使用pymysql操作MySQL错误代码1054和1064处理">
				<span class="desc oneline">Python使用pymysql操作MySQL错误代码1054和1064处理最近在学习用Python爬虫，需要用到mysql来存储从网络上爬到的数据，这里我也是借助了pymysql来操作mysql数据库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sodalife">来自：	<span class="blog_title"> sodalife的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392381878","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392381878","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<a href="https://bbs.csdn.net/topics/392381878" target="_blank">
		<h4 class="text-truncate oneline">
				mysql触发器 报错<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-19</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">CREATE TRIGGER zpcj_update BEFORE UPDATE ON e FOR EACH ROW BEGIN SELECT psbl,ksbl INTO @a, @b FROM o</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/240013869","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/240013869","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<a href="https://bbs.csdn.net/topics/240013869" target="_blank">
		<h4 class="text-truncate oneline">
				初学mysql, ERROR <em>1064</em> (42000)		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-18</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我初学MYSQL, 在华军软件下的5.0.51a版本。装上后只有第一次成功创建一个tabel，之后的每一次都提示ERROR 1064 (42000)。重装后也从没创建成功。到底ERROR 1064 (</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Destiny_strive/article/details/82698687","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Destiny_strive/article/details/82698687","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Destiny_strive/article/details/82698687" target="_blank" title="解决Mysql (1064) 错误: 1064 - You have an error in your SQL syntax;">
		<h4 class="text-truncate oneline">
				解决Mysql (<em>1064</em>) 错误: <em>1064</em> - You have an error in your SQL syntax;		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-14</span>
				<span class="read-num hover-hide">
					阅读数 
					6090</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Destiny_strive/article/details/82698687" target="_blank" title="解决Mysql (1064) 错误: 1064 - You have an error in your SQL syntax;">
				<span class="desc oneline">我在给数据库中的表添加数据的时候，写的语句是：INSERTINTOorderVALUES(2,'编号B')表结构：出现了错误：INSERTINTOorderVALUES(2,'编号B')1064-Yo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Destiny_strive">来自：	<span class="blog_title"> 迷途的羔羊的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/muronggangxi/article/details/79508808","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/muronggangxi/article/details/79508808","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/muronggangxi/article/details/79508808" target="_blank" title="mysql 1064错误   有三个错误  但是不知道在哪里   希望大神指教  在下感激不尽  谢谢！！！">
		<h4 class="text-truncate oneline">
				mysql <em>1064</em>错误   有三个错误  但是不知道在哪里   希望大神指教  在下感激不尽  谢谢！！！		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-10</span>
				<span class="read-num hover-hide">
					阅读数 
					398</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/muronggangxi/article/details/79508808" target="_blank" title="mysql 1064错误   有三个错误  但是不知道在哪里   希望大神指教  在下感激不尽  谢谢！！！">
				<span class="desc oneline">这是我的数据库文件 DROPDATABASEIFEXISTSmystock--建立数据库CREATEDATABASEIFNOTEXISTSbetatownDEFAULTCHARSETutf8COLLA...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/muronggangxi">来自：	<span class="blog_title"> muronggangxi的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390721829","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390721829","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<a href="https://bbs.csdn.net/topics/390721829" target="_blank">
		<h4 class="text-truncate oneline">
				mysql <em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-03</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">刚刚转mysql遇到不能更新，请高高手指点一下，代码如下： delimiter // CREATE PROCEDURE ZSP_ONE_IPT_HIST_PMT(IN PLCY VARCHAR(20)</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390728754","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/390728754","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<a href="https://bbs.csdn.net/topics/390728754" target="_blank">
		<h4 class="text-truncate oneline">
				MySql <em>1064</em>错误 函数		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-11</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">DELIMITER $$ create FUNCTION GETVLINKHEAD(PFLAG VARCHAR(3), IFLAG VARCHAR(3) ) RETURNS VARCHAR(400)</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43645330/article/details/83869490","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43645330/article/details/83869490","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43645330/article/details/83869490" target="_blank" title="mysql 修改root密码提示1064语法错误问题解决">
		<h4 class="text-truncate oneline">
				mysql 修改root密码提示<em>1064</em>语法错误问题解决		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-08</span>
				<span class="read-num hover-hide">
					阅读数 
					3076</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43645330/article/details/83869490" target="_blank" title="mysql 修改root密码提示1064语法错误问题解决">
				<span class="desc oneline">学习php初始，了解到数据库MySQL，笔者在安装过程中发现，mysql修改root密码时总是提示1064语法错误，1064语法错误提示如下首先使用mysql&amp;amp;gt;setpasswordfo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43645330">来自：	<span class="blog_title"> weixin_43645330的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43301156/article/details/89326970","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43301156/article/details/89326970","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43301156/article/details/89326970" target="_blank" title="mysql导入数据库错误#1064提示解决方法">
		<h4 class="text-truncate oneline">
				mysql导入数据库错误#<em>1064</em>提示解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-03</span>
				<span class="read-num hover-hide">
					阅读数 
					351</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43301156/article/details/89326970" target="_blank" title="mysql导入数据库错误#1064提示解决方法">
				<span class="desc oneline">小编在mysql导入数据库时出现错误#1064YouhaveanerrorinyourSQLsyntax提示，我们这和数据库没什么关系大多是sql语句问题，或是数据库版本不兼容的问题。	USINGBT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43301156">来自：	<span class="blog_title"> weixin_43301156的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/jacey_48557/article/details/6843917","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/jacey_48557/article/details/6843917","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jacey_48557/article/details/6843917" target="_blank" title="关于ADO连接MYSQL调用存储过程的ERROR1064错误">
		<h4 class="text-truncate oneline">
				关于ADO连接MYSQL调用存储过程的ERROR<em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-04</span>
				<span class="read-num hover-hide">
					阅读数 
					384</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jacey_48557/article/details/6843917" target="_blank" title="关于ADO连接MYSQL调用存储过程的ERROR1064错误">
				<span class="desc oneline">CREATEPROCEDUREJC_PROC_1(OUTnumberINTEGER)BEGIN SELECTCOUNT(*)INTOnumberFROMmydb.MYTABLE;END; ERROR1...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jacey_48557">来自：	<span class="blog_title"> jacey_48557的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sinianyichengge/article/details/49711807","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sinianyichengge/article/details/49711807","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinianyichengge/article/details/49711807" target="_blank" title="mysql 1064 USING BTREE问题">
		<h4 class="text-truncate oneline">
				mysql <em>1064</em> USING BTREE问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-08</span>
				<span class="read-num hover-hide">
					阅读数 
					182</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinianyichengge/article/details/49711807" target="_blank" title="mysql 1064 USING BTREE问题">
				<span class="desc oneline">从服务器上通过mysqldump命令导出文件在导入到另外的库时，提示:MySQL返回：#1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatcor...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinianyichengge">来自：	<span class="blog_title"> sinianyichengge的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_19865749/article/details/76146572","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_19865749/article/details/76146572","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_19865749/article/details/76146572" target="_blank" title="MySQL —— 1064错误，delete语句中 表名不能用别名">
		<h4 class="text-truncate oneline">
				MySQL —— <em>1064</em>错误，delete语句中 表名不能用别名		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-26</span>
				<span class="read-num hover-hide">
					阅读数 
					2702</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_19865749/article/details/76146572" target="_blank" title="MySQL —— 1064错误，delete语句中 表名不能用别名">
				<span class="desc oneline">DELETEFROMtable_name twheret......;报1064错误，原因MySQL中delete语句不能给表名起别名。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_19865749">来自：	<span class="blog_title"> 永远的北极光</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392191498","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392191498","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<a href="https://bbs.csdn.net/topics/392191498" target="_blank">
		<h4 class="text-truncate oneline">
				mysql数据库创建数据表时提示<em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-12</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我按照书上的打，还是错，输入法是用系统的小键盘。。到底哪里错了，请指点</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31334119/article/details/80109111","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31334119/article/details/80109111","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_31334119/article/details/80109111" target="_blank" title="Navicat for mysql导sql出现1064">
		<h4 class="text-truncate oneline">
				Navicat for mysql导sql出现<em>1064</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2881</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_31334119/article/details/80109111" target="_blank" title="Navicat for mysql导sql出现1064">
				<span class="desc oneline">近期对以前学习的知识做了回顾，在搭建项目之前，将之前的数据导入NavicatMysql时居然报了1064本来1064一搬是使用了SQL的保留字，SQL语句写错了才会出的错误，但是导入时报错，就有点懵，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_31334119">来自：	<span class="blog_title"> 阿狸演绎的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Qve1995/article/details/88396428","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Qve1995/article/details/88396428","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Qve1995/article/details/88396428" target="_blank" title="解决mysql报1064错误,并非SQL语句错误">
		<h4 class="text-truncate oneline">
				解决mysql报<em>1064</em>错误,并非SQL语句错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-11</span>
				<span class="read-num hover-hide">
					阅读数 
					618</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Qve1995/article/details/88396428" target="_blank" title="解决mysql报1064错误,并非SQL语句错误">
				<span class="desc oneline">CREATETABLE`product_info`(	`product_id`VARCHAR(32)NOTNULL,	`product_name`VARCHAR(64)NOTNULLCOMMENT'商...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Qve1995">来自：	<span class="blog_title"> Qve1995的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/guizishou00/article/details/51946691","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/guizishou00/article/details/51946691","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/guizishou00/article/details/51946691" target="_blank" title="MySQL 1064 错误解决方法">
		<h4 class="text-truncate oneline">
				MySQL <em>1064</em> 错误解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-18</span>
				<span class="read-num hover-hide">
					阅读数 
					2406</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/guizishou00/article/details/51946691" target="_blank" title="MySQL 1064 错误解决方法">
				<span class="desc oneline">原因：MySQL1064错误是关键字冲突了！！！这次是插入数据时遇到的错误，原来是我的SQL语句中，使用了关键字group(苦笑)。解决思路：1.直接复制用到的SQL语句，在navicat或者其它连接...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/guizishou00">来自：	<span class="blog_title"> guizishou00的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhj_1121/article/details/83549225","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhj_1121/article/details/83549225","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhj_1121/article/details/83549225" target="_blank" title="Mysql取中文别名出现1064错误">
		<h4 class="text-truncate oneline">
				Mysql取中文别名出现<em>1064</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-30</span>
				<span class="read-num hover-hide">
					阅读数 
					448</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhj_1121/article/details/83549225" target="_blank" title="Mysql取中文别名出现1064错误">
				<span class="desc oneline">使用中文别名时出现错误，而使用英文别名时正常解决方法：查看字符集//查看当前MySQL服务实例使用的字符集。showvariableslike'character%';设置字符集：//MySQL服务实...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhj_1121">来自：	<span class="blog_title"> zhj_1121的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/300228787","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/300228787","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<a href="https://bbs.csdn.net/topics/300228787" target="_blank">
		<h4 class="text-truncate oneline">
				求高手解决一下MySQL数据库中的<em>1064</em>号错误，急！		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-28</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我在使用MySQL创建数据库的时候遇到了问题（MySQL 5.0，Navicat 8）： 我对数据库了解不深，需要使用MySQL创建一个数据库。我选择了使用工具，先使用了powerdesigner建立</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtTaQg1sMTgtZWR1.html" target="_blank">
                        怎么学习互联网大数据</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtTaQg1sMTktZWR1.html" target="_blank">
                        村干部学习大数据心得</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/Ling1604">
              <img src="https://avatar.csdn.net/8/3/D/3_ling1604.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/3.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/Ling1604"  class="" id="uid">Ling1604</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="25">
                        <dt><a href="https://blog.csdn.net/ling1604?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/ling1604?t=1"><span class="count">25</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="2">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">2</span></dd>
        </dl>
        <dl class="text-center" title="2">
            <dt>喜欢</dt>
            <dd><span class="count">2</span></dd>
        </dl>
        <dl class="text-center" title="0">
            <dt>评论</dt>
            <dd><span class="count">0</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="23973">
                2万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="489">
                489            </dd>
        </dl>
        <dl title="149011">
            <dt>排名：</dt>
            <dd>14万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/Ling1604">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/Ling1604/article/details/84324166" target="_blank" >
                                        linux下tomcat部署注意点                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/Ling1604/article/details/79649916" target="_blank" >
                                        点击图片放大缩小功能                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/Ling1604/article/details/78527603" target="_blank" >
                                        Ionic学习总结                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/Ling1604/article/details/78516783" target="_blank" >
                                        Angular JS 学习笔记                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/Ling1604/article/details/78111682" target="_blank" >
                                        批量xml格式文件按字段顺序转json文件                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6891185">
                    <span class="title oneline">前端开发</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6914601">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6915096">
                    <span class="title oneline">软件工具</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6932240">
                    <span class="title oneline">java注解</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6933513">
                    <span class="title oneline">jdk</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/6962336">
                    <span class="title oneline">java异常</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/7168582">
                    <span class="title oneline">java</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/7197804">
                    <span class="title oneline">工具类</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/ling1604/article/category/8403745">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2018/11">
                    2018年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2018/03">
                    2018年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/11">
                    2017年11月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/09">
                    2017年9月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/07">
                    2017年7月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/06">
                    2017年6月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/05">
                    2017年5月                    <span class="count float-right">12篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/ling1604/article/month/2017/04">
                    2017年4月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/Ling1604/article/details/72381926" >
                                                由mysql函数UTC_DATE(),UTC_TIME()引出UTC                    </a>
					<p class="read">阅读数 <span>3714</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/Ling1604/article/details/71713692" >
                                                mysql错误：1064                    </a>
					<p class="read">阅读数 <span>3548</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/Ling1604/article/details/79649916" >
                                                点击图片放大缩小功能                    </a>
					<p class="read">阅读数 <span>2616</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/Ling1604/article/details/72723764" >
                                                js select 循环获取option的值                    </a>
					<p class="read">阅读数 <span>2242</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/Ling1604/article/details/72674169" >
                                                拼接option，并给其中一个option赋值                    </a>
					<p class="read">阅读数 <span>2062</span></p>
				</li>
					</ul>
	</div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">1</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/ling1604/article/details/71711352" title="mysql存储过程语法及实例">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/ling1604/article/details/71727734" title="常用工具推荐">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/ling1604/article/details/71711352" title="mysql存储过程语法及实例">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/ling1604/article/details/71727734" title="常用工具推荐">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "71713692";
    var commentscount = 0;
    var islock = true;
    var curentUrl = "https://blog.csdn.net/Ling1604/article/details/71713692";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 1;
    //百度搜索
    var baiduKey = "mysql错误：1064 - Ling1604的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql\u9519\u8bef","1064"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
